2015-09-15 - 21437.300 - Spec - New UPC label DUNS14 (LA7) (Lizz by 2015-09-30) #ABAPUPC #SDLABELREPORTS #US #SDSupportUPCLabels

SPECIFICATIONS

21437.300- New UPC label DUNS14

Purpose

Add new UPC label DUNS14.LWL (LA7) in UPC program.

Admin Info

Purpose	Add new Lcode LA7 in the UPC program
Requested By	Lizz Paxson
Spec Created By	Siba
Spec Created Date	09/15/2015
Spec QA by	Siba
Objects	ZTSD_CODES ZRSD_UPC_LABELS
Document Status	Completed

Estimates

Sl.No	Activity	Estimation in Hours
1	Research	4
2	Documentation	3
3	Development/ Config	8
4	Unit test in DEV	4
5	Unit test in QUA	4
6	Other activity	0
	TOTAL	23

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]
NA

Documents

[Attach any document(s) received for the requirement(s)]
NA

Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.	Change Details	Requested By	Requested On	Notes if any
1	Add New LCode- LA7 in the UPC program	Lizz Paxson	09/15/2015	NA
2	UpdateUPC program with LA7 at particular place, which was missed in last change	Lizz Paxson	10/06/2015	NA
3	Update UPC program logic for Material Input with Dual currency calculation for LBJ-S23	Lizz Paxson	10/06/2015	NA

Functional Requirement

Purpose/WHY:

Update the UPC program with below requirements:

Add new Lcode- LA7 with label Duns14.lwl, which should work with LA7-S31
Logic in Material input and currency for LBJ-S23 i.e. Dual currency

In Scope:

Dual currency logic updated for LBJ-S23 only

Out of Scope:

Changes required only for Lcode LA7 , LBJ-S23 only.

Solution Summary

Added new Lcode with label Duns14.lwl for LA7-S31.
Added new logic for material input and currency for LBJ-S23 and changed logic for Dual currency.

Test Plan

Below are the scenarios can be executed to test the above change.

To test VAS Code - LA7-S31, below tests required to test.

Test ID	Test Scenarios	Expected Results
SD001	For Stock items: Create a Production order execute in ZSD_UPCLBL T.code under UPC(stock items only).	The condition record should be fetched from the below tables in series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type As the entry in 901 table is deleted i.e. with customer NEC0135 and VAS mat.grp APL the entry of 906 table is considered for the L and S codes ie., LA7 and S31
SD002	For Stock items: Execute ZSD_UPCLBL t.code with the below inputs. Material,size,qty,S.org,cur,MSRP	The condition record should be fetched from the below tables in a series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type As the 901 table condition record has been deleted the L and S codes from 906 table should be considered to print the labels LA7 and S31 with the given input quantities.
SD003	For Stock items: Create a Purchase order with some deleted materials (EA) and execute in ZSD_UPCLBL T.code under UPC(stock items only) with print components flagged.	The condition record should be fetched from the below tables in series. KOTK912 (Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr) KOTK901 (Sales org./Distr. Chl/Division/Customer/VAS Mat.gr) KOTK922 (Sales org./Distr. Chl/Division/Plant) Only the undeleted material sizes should get printed in the output. Labels should be printed from table 912, as there is an entry exist in table 912 i.e. with Sorg-1000, Dist.chnl-10, Div-00, Plant-0110, VAS mat.gr- HDW & VAS Code- LA7, S31.
SD004	For Customer Specific items: Create MTO sales order with no L codes and corresponding Production order and execute in ZSD_UPCLBL T.code.	The condition record should be fetched from KOTK901 table ie., Sales org./Distr. Chl/Division/Customer/VAS Mat.gr There is no VAS code maintained in the sales order, then the VAS codes will be picked from 901 table. which has been maintained with Sorg-1000, Distchnl- 10, Div-00, Cust- 1000018, VAS mat. grp- HDW. With LA7 & S31.
SD005	For Customer specific labels: Create a SO with VAS codes and execute in ZSD_UPCLBL T.code under customer specific labels	Program will check first sales order for VAS Condition maintained or not then it will check table 901. As sales order has maintained VAS code i.e LA7 , S31 and it will be printed.
SD006	For Customer specific labels: Create a SO with same VAS codes for all items and execute in ZSD_UPCLBL T.code under customer specific labels with below inputs. SO number,material number from the SO,size,qty	The VAS codes in the SO (LA7,S31) for the given item should be considered for printing the labels with the given quantities.
SD007	For Customer specific labels: Execute ZSD_UPCLBL t.code with the below inputs. S.org,Cust,Material,size,Qty	The L and S codes should be fetched from the below tables in series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type The condition record in 901 table with Cust 1000018 and VAS material grp HDW is considered to print labels ie., LA7, S31 with the given input quantities.

To test VAS Code - LBJ-S23, below tests required to test.

Test ID	Test Scenarios	Expected Results
SD001	For Stock items: Execute ZSD_UPCLBL t.code with the below inputs. Material,size,qty,S.org,cur,MSRP	The condition record should be fetched from the below tables in a series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type KOTK904 Sales org. KOTK922 Sales org./Distr. Chl/Division/Plant When multiple condition record available i.e for table 901 & 904. Then the condition record from 901 table should be used to print the labels ie., LBJ,S23 with given input quantities.
SD002	For Stock items: Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only)	The condition record should be fetched from the below tables in a series. KOTK912 Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant As the condition record is maintained in 912 table. The condition record from 912 table should be used to print the labels ie., LBJ,S23 with given input.
SD003	For Stock items: Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only)	The condition record should be fetched from the below tables in a series. KOTK912 Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant When multiple condition record available i.e for table 912 & 901. And the condition record from table 912 is deleted. Then the condition record from 901 table should be used to print the labels ie., LBJ,S23 with given input.
SD004	For Stock items: Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only) Check Print component	The condition record should be fetched from the below tables in a series. KOTK912 Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant When multiple condition record available i.e for table 912 & 901. And the condition record from table 912 is deleted. Then the condition record from 901 table should be used to print the labels ie., LBJ,S23 with given input. PO components should be printed with above L & S code.
SD005	For Customer specific labels: Create a SO with no VAS codes and execute in ZSD_UPCLBL T.code under customer specific labels	The condition record should be fetched from the below tables in series. First from sales order then from below 901 table. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr When multiple condition records available i.e at Sales order and table 901. Then from Sales order, L & S codes will be printed i.e LBJ & S23
SD006	For Customer specific labels: Create a SO with no VAS codes and execute in ZSD_UPCLBL T.code under customer specific labels	The condition record should be fetched from the below tables in series. First from sales order then from below 901 table. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr When L & S codes are not maintained in sales order, then from table 901 L & S codes will be printed i.e LBJ & S23.
SD007	For Customer specific labels: Create a SO with no VAS codes and execute in ZSD_UPCLBL T.code under customer specific labels with below inputs. SO number,material number from the SO,size,qty	The condition record should be fetched from the below tables in series. First from sales order then from below 901 table. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr When L & S codes are not maintained in sales order, then from table 901 L & S codes will be printed i.e LBJ & S23. The condition record is read from the 901 table only with customer NEC0135 and VAS mat.grp HDW with the given input quantities.
SD008	For Customer specific labels: Create a SO with no VAS codes and execute in ZSD_UPCLBL T.code under customer specific labels with below inputs. SO number,material number from the SO,size,qty	The condition record should be fetched from the below tables in series. First from sales order then from below 901 table. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr When multiple condition records available i.e at Sales order and table 901. Then from Sales order L & S codes will be printed i.e LBJ & S23 with the given input.
SD009	For Customer specific labels: Execute ZSD_UPCLBL t.code with the below inputs. S.org,Cust,Material,size,Qty	The condition record should be fetched from the below tables in a series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type KOTK904 Sales org. KOTK922 Sales org./Distr. Chl/Division/Plant When multiple condition record available i.e for table 901 & 904. Then the condition record from 901 table should be used to print the labels ie., LBJ,S23 with given input quantities.
SD010	For Stock items: Execute ZSD_UPCLBL t.code with the below inputs. Material,size,qty,S.org,cur	The condition record should be fetched from the below tables in a series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type KOTK904 Sales org. KOTK922 Sales org./Distr. Chl/Division/Plant When no condition records are available for the above table with given input, then output message ' No relevant L-Code or S-Code found' should appear.

Solution Details

The logic has been added in the program ZRSD_UPC_LABELS to get the label Duns14.lwl for LA7-S31 for various inputs.
The changes have been made in the program for sales order,material,size and quantity input for LBJ-S23.
The dual currency logic has been added in the program for sales order,material,size and quantity input.
Logic of retrieving data of currencies GBP and EUR from KONV table has been added to get dual currency in the label.

Issues

While printing LBJ-S23 (Dual Currency), currency symbol was not getting printed in the label.
With LBJ-S23 and Input- Sales Order, Material, Size & Qty the dual currency was not getting printed.